import sqlite3

with sqlite3.connect("library.db") as conn:
    cursor=conn.cursor()
    sql1='''CREATE TABLE IF NOT EXISTS books(id integer primary key,
    title text not null,
    author text not null,
    publication_year integer,
    status text default 'available')'''
    cursor.execute(sql1)
    books_to_add = [
    ('The Three-Body Problem', 'Cixin Liu', 2008),
    ('1984', 'George Orwell', 1949),
    ('To Kill a Mockingbird', 'Harper Lee', 1960),
    ('The Great Gatsby', 'F. Scott Fitzgerald', 1925),
    ('Project Hail Mary', 'Andy Weir', 2021)
]
    sql2='''INSERT INTO books(title,author,publication_year)values(?,?,?)'''
    cursor.executemany(sql2,books_to_add)
    